Overview
Brought to you by YData
Dataset statistics
| Number of variables | 44 |
|---|---|
| Number of observations | 119143 |
| Missing cells | 211772 |
| Missing cells (%) | 4.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 228.0 MiB |
| Average record size in memory | 2.0 KiB |
Variable types
| Text | 13 |
|---|---|
| Categorical | 6 |
| DateTime | 8 |
| Numeric | 17 |
customer_state is highly overall correlated with customer_zip_code_prefix | High correlation |
customer_zip_code_prefix is highly overall correlated with customer_state | High correlation |
geolocation_lat is highly overall correlated with geolocation_state and 1 other fields | High correlation |
geolocation_lng is highly overall correlated with geolocation_state and 1 other fields | High correlation |
geolocation_state is highly overall correlated with geolocation_lat and 3 other fields | High correlation |
payment_value is highly overall correlated with price | High correlation |
price is highly overall correlated with payment_value and 1 other fields | High correlation |
product_height_cm is highly overall correlated with product_weight_g | High correlation |
product_length_cm is highly overall correlated with product_weight_g and 1 other fields | High correlation |
product_weight_g is highly overall correlated with price and 3 other fields | High correlation |
product_width_cm is highly overall correlated with product_length_cm and 1 other fields | High correlation |
seller_state is highly overall correlated with geolocation_lat and 3 other fields | High correlation |
zip_code_prefix is highly overall correlated with geolocation_state and 1 other fields | High correlation |
order_status is highly imbalanced (91.6%) | Imbalance |
payment_type is highly imbalanced (52.6%) | Imbalance |
seller_state is highly imbalanced (63.3%) | Imbalance |
geolocation_state is highly imbalanced (62.3%) | Imbalance |
order_delivered_carrier_date has 2086 (1.8%) missing values | Missing |
order_delivered_customer_date has 3421 (2.9%) missing values | Missing |
review_comment_title has 105154 (88.3%) missing values | Missing |
review_comment_message has 68898 (57.8%) missing values | Missing |
product_category_name has 2542 (2.1%) missing values | Missing |
product_name_lenght has 2542 (2.1%) missing values | Missing |
product_description_lenght has 2542 (2.1%) missing values | Missing |
product_photos_qty has 2542 (2.1%) missing values | Missing |
product_category_name_english has 2567 (2.2%) missing values | Missing |
Reproduction
| Analysis started | 2025-07-05 23:22:31.531273 |
|---|---|
| Analysis finished | 2025-07-05 23:24:03.199030 |
| Duration | 1 minute and 31.67 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
order_id
Text
| Distinct | 99441 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 86494 ? |
|---|---|
| Unique (%) | 72.6% |
Sample
| 1st row | e481f51cbdc54678b7cc49136f2d6af7 |
|---|---|
| 2nd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 3rd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 4th row | 53cdb2fc8bc7dce0b6741e2150273451 |
| 5th row | 47770eb9100c2d0c44946d9cf07ec65d |
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| 6d58638e32674bebee793a47ac4cbadc | 24 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| 285c2e15bebd4ac83635ccc563dc71f4 | 22 | < 0.1% |
| Other values (99431) | 118845 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 239371 | 6.3% |
| b | 239344 | 6.3% |
| 6 | 239250 | 6.3% |
| e | 238956 | 6.3% |
| 3 | 238724 | 6.3% |
| c | 238563 | 6.3% |
| 8 | 238518 | 6.3% |
| 7 | 238501 | 6.3% |
| 1 | 238422 | 6.3% |
| a | 238162 | 6.2% |
| Other values (6) | 1424765 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 239371 | 6.3% |
| b | 239344 | 6.3% |
| 6 | 239250 | 6.3% |
| e | 238956 | 6.3% |
| 3 | 238724 | 6.3% |
| c | 238563 | 6.3% |
| 8 | 238518 | 6.3% |
| 7 | 238501 | 6.3% |
| 1 | 238422 | 6.3% |
| a | 238162 | 6.2% |
| Other values (6) | 1424765 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 239371 | 6.3% |
| b | 239344 | 6.3% |
| 6 | 239250 | 6.3% |
| e | 238956 | 6.3% |
| 3 | 238724 | 6.3% |
| c | 238563 | 6.3% |
| 8 | 238518 | 6.3% |
| 7 | 238501 | 6.3% |
| 1 | 238422 | 6.3% |
| a | 238162 | 6.2% |
| Other values (6) | 1424765 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 239371 | 6.3% |
| b | 239344 | 6.3% |
| 6 | 239250 | 6.3% |
| e | 238956 | 6.3% |
| 3 | 238724 | 6.3% |
| c | 238563 | 6.3% |
| 8 | 238518 | 6.3% |
| 7 | 238501 | 6.3% |
| 1 | 238422 | 6.3% |
| a | 238162 | 6.2% |
| Other values (6) | 1424765 |
customer_id
Text
| Distinct | 99441 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 86494 ? |
|---|---|
| Unique (%) | 72.6% |
Sample
| 1st row | 9ef432eb6251297304e76186b10a928d |
|---|---|
| 2nd row | 9ef432eb6251297304e76186b10a928d |
| 3rd row | 9ef432eb6251297304e76186b10a928d |
| 4th row | b0830fb4747a6c6d20dea0b8c802d7ef |
| 5th row | 41ce2a54c0b03bf3443c3d931a367089 |
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| 2ba91e12e5e4c9f56b82b86d9031d329 | 24 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| b246eeed30b362c09d867b9e598bee51 | 22 | < 0.1% |
| Other values (99431) | 118845 |
Most occurring characters
| Value | Count | Frequency (%) |
| f | 239014 | 6.3% |
| 2 | 238989 | 6.3% |
| 5 | 238748 | 6.3% |
| c | 238647 | 6.3% |
| 6 | 238555 | 6.3% |
| 1 | 238489 | 6.3% |
| 8 | 238361 | 6.3% |
| d | 238357 | 6.3% |
| 7 | 238270 | 6.2% |
| a | 238267 | 6.2% |
| Other values (6) | 1426879 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| f | 239014 | 6.3% |
| 2 | 238989 | 6.3% |
| 5 | 238748 | 6.3% |
| c | 238647 | 6.3% |
| 6 | 238555 | 6.3% |
| 1 | 238489 | 6.3% |
| 8 | 238361 | 6.3% |
| d | 238357 | 6.3% |
| 7 | 238270 | 6.2% |
| a | 238267 | 6.2% |
| Other values (6) | 1426879 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| f | 239014 | 6.3% |
| 2 | 238989 | 6.3% |
| 5 | 238748 | 6.3% |
| c | 238647 | 6.3% |
| 6 | 238555 | 6.3% |
| 1 | 238489 | 6.3% |
| 8 | 238361 | 6.3% |
| d | 238357 | 6.3% |
| 7 | 238270 | 6.2% |
| a | 238267 | 6.2% |
| Other values (6) | 1426879 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| f | 239014 | 6.3% |
| 2 | 238989 | 6.3% |
| 5 | 238748 | 6.3% |
| c | 238647 | 6.3% |
| 6 | 238555 | 6.3% |
| 1 | 238489 | 6.3% |
| 8 | 238361 | 6.3% |
| d | 238357 | 6.3% |
| 7 | 238270 | 6.2% |
| a | 238267 | 6.2% |
| Other values (6) | 1426879 |
order_status
Categorical
Imbalance 
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.5 MiB |
| delivered | |
|---|---|
| shipped | 1256 |
| canceled | 750 |
| unavailable | 652 |
| invoiced | 378 |
| Other values (3) | 384 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.9834401 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 115723 | |
| shipped | 1256 | 1.1% |
| canceled | 750 | 0.6% |
| unavailable | 652 | 0.5% |
| invoiced | 378 | 0.3% |
| processing | 376 | 0.3% |
| created | 5 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| delivered | 115723 | |
| shipped | 1256 | 1.1% |
| canceled | 750 | 0.6% |
| unavailable | 652 | 0.5% |
| invoiced | 378 | 0.3% |
| processing | 376 | 0.3% |
| created | 5 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 351344 | |
| d | 233838 | |
| i | 118763 | 11.1% |
| l | 117777 | 11.0% |
| v | 116756 | 10.9% |
| r | 116107 | 10.8% |
| p | 2894 | 0.3% |
| a | 2714 | 0.3% |
| c | 2259 | 0.2% |
| n | 2156 | 0.2% |
| Other values (7) | 5706 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1070314 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 351344 | |
| d | 233838 | |
| i | 118763 | 11.1% |
| l | 117777 | 11.0% |
| v | 116756 | 10.9% |
| r | 116107 | 10.8% |
| p | 2894 | 0.3% |
| a | 2714 | 0.3% |
| c | 2259 | 0.2% |
| n | 2156 | 0.2% |
| Other values (7) | 5706 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1070314 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 351344 | |
| d | 233838 | |
| i | 118763 | 11.1% |
| l | 117777 | 11.0% |
| v | 116756 | 10.9% |
| r | 116107 | 10.8% |
| p | 2894 | 0.3% |
| a | 2714 | 0.3% |
| c | 2259 | 0.2% |
| n | 2156 | 0.2% |
| Other values (7) | 5706 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1070314 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 351344 | |
| d | 233838 | |
| i | 118763 | 11.1% |
| l | 117777 | 11.0% |
| v | 116756 | 10.9% |
| r | 116107 | 10.8% |
| p | 2894 | 0.3% |
| a | 2714 | 0.3% |
| c | 2259 | 0.2% |
| n | 2156 | 0.2% |
| Other values (7) | 5706 | 0.5% |
| Distinct | 98875 |
|---|---|
| Distinct (%) | 83.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 930.9 KiB |
| Minimum | 2016-09-04 21:15:19 |
|---|---|
| Maximum | 2018-10-17 17:30:18 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 90733 |
|---|---|
| Distinct (%) | 76.3% |
| Missing | 177 |
| Missing (%) | 0.1% |
| Memory size | 930.9 KiB |
| Minimum | 2016-09-15 12:16:38 |
|---|---|
| Maximum | 2018-09-03 17:40:06 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
order_delivered_carrier_date
Date
Missing 
| Distinct | 81018 |
|---|---|
| Distinct (%) | 69.2% |
| Missing | 2086 |
| Missing (%) | 1.8% |
| Memory size | 930.9 KiB |
| Minimum | 2016-10-08 10:34:01 |
|---|---|
| Maximum | 2018-09-11 19:48:28 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
order_delivered_customer_date
Date
Missing 
| Distinct | 95664 |
|---|---|
| Distinct (%) | 82.7% |
| Missing | 3421 |
| Missing (%) | 2.9% |
| Memory size | 930.9 KiB |
| Minimum | 2016-10-11 13:46:32 |
|---|---|
| Maximum | 2018-10-17 13:22:46 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 459 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 930.9 KiB |
| Minimum | 2016-09-30 00:00:00 |
|---|---|
| Maximum | 2018-11-12 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 96096 |
|---|---|
| Distinct (%) | 80.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 81601 ? |
|---|---|
| Unique (%) | 68.5% |
Sample
| 1st row | 7c396fd4830fd04220f754e42b4e5bff |
|---|---|
| 2nd row | 7c396fd4830fd04220f754e42b4e5bff |
| 3rd row | 7c396fd4830fd04220f754e42b4e5bff |
| 4th row | af07308b275d755c9edb36a90c618231 |
| 5th row | 3a653a41f6f9fc3d2a113cf8398680e8 |
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| d97b3cfb22b0d6b25ac9ed4e9c2d481b | 24 | < 0.1% |
| 5419a7c9b86a43d8140e2939cd2c2f7e | 24 | < 0.1% |
| db1af3fd6b23ac3873ef02619d548f9c | 24 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| 85963fd37bfd387aa6d915d8a1065486 | 24 | < 0.1% |
| Other values (96086) | 118820 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 239302 | 6.3% |
| b | 238901 | 6.3% |
| 1 | 238720 | 6.3% |
| a | 238717 | 6.3% |
| d | 238546 | 6.3% |
| 3 | 238474 | 6.3% |
| 8 | 238431 | 6.3% |
| e | 238285 | 6.2% |
| 5 | 238244 | 6.2% |
| 2 | 238230 | 6.2% |
| Other values (6) | 1426726 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 6 | 239302 | 6.3% |
| b | 238901 | 6.3% |
| 1 | 238720 | 6.3% |
| a | 238717 | 6.3% |
| d | 238546 | 6.3% |
| 3 | 238474 | 6.3% |
| 8 | 238431 | 6.3% |
| e | 238285 | 6.2% |
| 5 | 238244 | 6.2% |
| 2 | 238230 | 6.2% |
| Other values (6) | 1426726 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 6 | 239302 | 6.3% |
| b | 238901 | 6.3% |
| 1 | 238720 | 6.3% |
| a | 238717 | 6.3% |
| d | 238546 | 6.3% |
| 3 | 238474 | 6.3% |
| 8 | 238431 | 6.3% |
| e | 238285 | 6.2% |
| 5 | 238244 | 6.2% |
| 2 | 238230 | 6.2% |
| Other values (6) | 1426726 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3812576 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 6 | 239302 | 6.3% |
| b | 238901 | 6.3% |
| 1 | 238720 | 6.3% |
| a | 238717 | 6.3% |
| d | 238546 | 6.3% |
| 3 | 238474 | 6.3% |
| 8 | 238431 | 6.3% |
| e | 238285 | 6.2% |
| 5 | 238244 | 6.2% |
| 2 | 238230 | 6.2% |
| Other values (6) | 1426726 |
customer_zip_code_prefix
Real number (ℝ)
High correlation 
| Distinct | 14994 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35033.451 |
| Minimum | 1003 |
|---|---|
| Maximum | 99990 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3275 |
| Q1 | 11250 |
| median | 24240 |
| Q3 | 58475 |
| 95-th percentile | 90570 |
| Maximum | 99990 |
| Range | 98987 |
| Interquartile range (IQR) | 47225 |
Descriptive statistics
| Standard deviation | 29823.199 |
|---|---|
| Coefficient of variation (CV) | 0.85127779 |
| Kurtosis | -0.78102574 |
| Mean | 35033.451 |
| Median Absolute Deviation (MAD) | 16230 |
| Skewness | 0.7854738 |
| Sum | 4.1739905 × 109 |
| Variance | 8.894232 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24220 | 164 | 0.1% |
| 22790 | 155 | 0.1% |
| 22793 | 154 | 0.1% |
| 24230 | 141 | 0.1% |
| 22775 | 130 | 0.1% |
| 35162 | 125 | 0.1% |
| 29101 | 119 | 0.1% |
| 11740 | 111 | 0.1% |
| 13087 | 108 | 0.1% |
| 13212 | 106 | 0.1% |
| Other values (14984) | 117830 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 4 | |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 3 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99990 | 1 | < 0.1% |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 2 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 9 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
customer_city
Text
| Distinct | 4119 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 7.7 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 27 |
| Mean length | 10.33532 |
| Min length | 3 |
Unique
| Unique | 1036 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | sao paulo |
|---|---|
| 2nd row | sao paulo |
| 3rd row | sao paulo |
| 4th row | barreiras |
| 5th row | vianopolis |
| Value | Count | Frequency (%) |
| sao | 25445 | 12.2% |
| paulo | 18957 | 9.1% |
| de | 11657 | 5.6% |
| rio | 9967 | 4.8% |
| janeiro | 8311 | 4.0% |
| do | 5095 | 2.4% |
| belo | 3373 | 1.6% |
| horizonte | 3327 | 1.6% |
| brasilia | 2510 | 1.2% |
| porto | 1998 | 1.0% |
| Other values (3285) | 118347 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 203082 | |
| o | 151991 | |
| i | 94150 | 7.6% |
| r | 91236 | 7.4% |
| 89844 | 7.3% | |
| e | 79953 | 6.5% |
| s | 75446 | 6.1% |
| n | 54566 | 4.4% |
| u | 54064 | 4.4% |
| l | 53676 | 4.4% |
| Other values (21) | 283373 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1231381 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 203082 | |
| o | 151991 | |
| i | 94150 | 7.6% |
| r | 91236 | 7.4% |
| 89844 | 7.3% | |
| e | 79953 | 6.5% |
| s | 75446 | 6.1% |
| n | 54566 | 4.4% |
| u | 54064 | 4.4% |
| l | 53676 | 4.4% |
| Other values (21) | 283373 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1231381 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 203082 | |
| o | 151991 | |
| i | 94150 | 7.6% |
| r | 91236 | 7.4% |
| 89844 | 7.3% | |
| e | 79953 | 6.5% |
| s | 75446 | 6.1% |
| n | 54566 | 4.4% |
| u | 54064 | 4.4% |
| l | 53676 | 4.4% |
| Other values (21) | 283373 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1231381 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 203082 | |
| o | 151991 | |
| i | 94150 | 7.6% |
| r | 91236 | 7.4% |
| 89844 | 7.3% | |
| e | 79953 | 6.5% |
| s | 75446 | 6.1% |
| n | 54566 | 4.4% |
| u | 54064 | 4.4% |
| l | 53676 | 4.4% |
| Other values (21) | 283373 |
customer_state
Categorical
High correlation 
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.7 MiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | BA |
| 5th row | GO |
Common Values
| Value | Count | Frequency (%) |
| SP | 50265 | |
| RJ | 15518 | 13.0% |
| MG | 13819 | 11.6% |
| RS | 6573 | 5.5% |
| PR | 6043 | 5.1% |
| SC | 4345 | 3.6% |
| BA | 4091 | 3.4% |
| DF | 2516 | 2.1% |
| GO | 2466 | 2.1% |
| ES | 2360 | 2.0% |
| Other values (17) | 11147 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 50265 | |
| rj | 15518 | 13.0% |
| mg | 13819 | 11.6% |
| rs | 6573 | 5.5% |
| pr | 6043 | 5.1% |
| sc | 4345 | 3.6% |
| ba | 4091 | 3.4% |
| df | 2516 | 2.1% |
| go | 2466 | 2.1% |
| es | 2360 | 2.0% |
| Other values (17) | 11147 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 64808 | |
| P | 60647 | |
| R | 29104 | |
| M | 16842 | 7.1% |
| G | 16285 | 6.8% |
| J | 15518 | 6.5% |
| A | 6892 | 2.9% |
| E | 6234 | 2.6% |
| C | 6005 | 2.5% |
| B | 4735 | 2.0% |
| Other values (7) | 11216 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 238286 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 64808 | |
| P | 60647 | |
| R | 29104 | |
| M | 16842 | 7.1% |
| G | 16285 | 6.8% |
| J | 15518 | 6.5% |
| A | 6892 | 2.9% |
| E | 6234 | 2.6% |
| C | 6005 | 2.5% |
| B | 4735 | 2.0% |
| Other values (7) | 11216 | 4.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 238286 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 64808 | |
| P | 60647 | |
| R | 29104 | |
| M | 16842 | 7.1% |
| G | 16285 | 6.8% |
| J | 15518 | 6.5% |
| A | 6892 | 2.9% |
| E | 6234 | 2.6% |
| C | 6005 | 2.5% |
| B | 4735 | 2.0% |
| Other values (7) | 11216 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 238286 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 64808 | |
| P | 60647 | |
| R | 29104 | |
| M | 16842 | 7.1% |
| G | 16285 | 6.8% |
| J | 15518 | 6.5% |
| A | 6892 | 2.9% |
| E | 6234 | 2.6% |
| C | 6005 | 2.5% |
| B | 4735 | 2.0% |
| Other values (7) | 11216 | 4.7% |
payment_sequential
Real number (ℝ)
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0947373 |
| Minimum | 1 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 29 |
| Range | 28 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.73014099 |
|---|---|
| Coefficient of variation (CV) | 0.66695545 |
| Kurtosis | 342.28301 |
| Mean | 1.0947373 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.775506 |
| Sum | 130427 |
| Variance | 0.53310587 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 113999 | |
| 2 | 3415 | 2.9% |
| 3 | 658 | 0.6% |
| 4 | 322 | 0.3% |
| 5 | 194 | 0.2% |
| 6 | 136 | 0.1% |
| 7 | 94 | 0.1% |
| 8 | 63 | 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 42 | < 0.1% |
| Other values (19) | 166 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 113999 | |
| 2 | 3415 | 2.9% |
| 3 | 658 | 0.6% |
| 4 | 322 | 0.3% |
| 5 | 194 | 0.2% |
| 6 | 136 | 0.1% |
| 7 | 94 | 0.1% |
| 8 | 63 | 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 42 | < 0.1% |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 2 | < 0.1% |
| 24 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| 22 | 3 | |
| 21 | 6 | |
| 20 | 6 |
payment_type
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 7.6 MiB |
| credit_card | |
|---|---|
| boleto | |
| voucher | 6465 |
| debit_card | 1706 |
| not_defined | 3 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.7954004 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | voucher |
| 3rd row | voucher |
| 4th row | boleto |
| 5th row | credit_card |
Common Values
| Value | Count | Frequency (%) |
| credit_card | 87776 | |
| boleto | 23190 | 19.5% |
| voucher | 6465 | 5.4% |
| debit_card | 1706 | 1.4% |
| not_defined | 3 | < 0.1% |
| (Missing) | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| credit_card | 87776 | |
| boleto | 23190 | 19.5% |
| voucher | 6465 | 5.4% |
| debit_card | 1706 | 1.4% |
| not_defined | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 183723 | |
| r | 183723 | |
| d | 178970 | |
| e | 119143 | |
| t | 112675 | |
| i | 89485 | |
| _ | 89485 | |
| a | 89482 | |
| o | 52848 | 4.5% |
| b | 24896 | 2.1% |
| Other values (6) | 42594 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1167024 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| c | 183723 | |
| r | 183723 | |
| d | 178970 | |
| e | 119143 | |
| t | 112675 | |
| i | 89485 | |
| _ | 89485 | |
| a | 89482 | |
| o | 52848 | 4.5% |
| b | 24896 | 2.1% |
| Other values (6) | 42594 | 3.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1167024 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| c | 183723 | |
| r | 183723 | |
| d | 178970 | |
| e | 119143 | |
| t | 112675 | |
| i | 89485 | |
| _ | 89485 | |
| a | 89482 | |
| o | 52848 | 4.5% |
| b | 24896 | 2.1% |
| Other values (6) | 42594 | 3.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1167024 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| c | 183723 | |
| r | 183723 | |
| d | 178970 | |
| e | 119143 | |
| t | 112675 | |
| i | 89485 | |
| _ | 89485 | |
| a | 89482 | |
| o | 52848 | 4.5% |
| b | 24896 | 2.1% |
| Other values (6) | 42594 | 3.6% |
payment_installments
Real number (ℝ)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9412456 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.7778477 |
|---|---|
| Coefficient of variation (CV) | 0.94444604 |
| Kurtosis | 2.5065453 |
| Mean | 2.9412456 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.6198199 |
| Sum | 350420 |
| Variance | 7.7164381 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 59446 | |
| 2 | 13838 | 11.6% |
| 3 | 11889 | 10.0% |
| 4 | 8072 | 6.8% |
| 10 | 6976 | 5.9% |
| 5 | 6097 | 5.1% |
| 8 | 5120 | 4.3% |
| 6 | 4674 | 3.9% |
| 7 | 1848 | 1.6% |
| 9 | 739 | 0.6% |
| Other values (14) | 441 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 59446 | |
| 2 | 13838 | 11.6% |
| 3 | 11889 | 10.0% |
| 4 | 8072 | 6.8% |
| 5 | 6097 | 5.1% |
| 6 | 4674 | 3.9% |
| 7 | 1848 | 1.6% |
| 8 | 5120 | 4.3% |
| 9 | 739 | 0.6% |
| Value | Count | Frequency (%) |
| 24 | 34 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 6 | < 0.1% |
| 20 | 21 | < 0.1% |
| 18 | 38 | |
| 17 | 8 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 93 | |
| 14 | 16 | < 0.1% |
payment_value
Real number (ℝ)
High correlation 
| Distinct | 29077 |
|---|---|
| Distinct (%) | 24.4% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.73514 |
| Minimum | 0 |
|---|---|
| Maximum | 13664.08 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.1 |
| Q1 | 60.85 |
| median | 108.16 |
| Q3 | 189.24 |
| 95-th percentile | 515.93 |
| Maximum | 13664.08 |
| Range | 13664.08 |
| Interquartile range (IQR) | 128.39 |
Descriptive statistics
| Standard deviation | 267.77608 |
|---|---|
| Coefficient of variation (CV) | 1.550212 |
| Kurtosis | 500.3632 |
| Mean | 172.73514 |
| Median Absolute Deviation (MAD) | 56.64 |
| Skewness | 13.965989 |
| Sum | 20579664 |
| Variance | 71704.027 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 351 | 0.3% |
| 100 | 300 | 0.3% |
| 20 | 286 | 0.2% |
| 77.57 | 250 | 0.2% |
| 35 | 166 | 0.1% |
| 73.34 | 160 | 0.1% |
| 30 | 139 | 0.1% |
| 116.94 | 133 | 0.1% |
| 56.78 | 123 | 0.1% |
| 107.78 | 120 | 0.1% |
| Other values (29067) | 117112 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 0.01 | 6 | |
| 0.03 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | < 0.1% |
| 0.11 | 2 | < 0.1% |
| 0.13 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 13664.08 | 8 | |
| 7274.88 | 4 | |
| 6929.31 | 1 | < 0.1% |
| 6922.21 | 1 | < 0.1% |
| 6726.66 | 1 | < 0.1% |
| 6081.54 | 6 | |
| 4950.34 | 1 | < 0.1% |
| 4809.44 | 2 | < 0.1% |
| 4764.34 | 1 | < 0.1% |
| 4681.78 | 1 | < 0.1% |
review_id
Text
| Distinct | 98410 |
|---|---|
| Distinct (%) | 83.3% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Memory size | 10.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 85411 ? |
|---|---|
| Unique (%) | 72.3% |
Sample
| 1st row | a54f0611adc9ed256b57ede6b6eb5114 |
|---|---|
| 2nd row | a54f0611adc9ed256b57ede6b6eb5114 |
| 3rd row | a54f0611adc9ed256b57ede6b6eb5114 |
| 4th row | 8d5266042046a06655c8db133d120ba5 |
| 5th row | e73b67b67587f7644d5bd1a52deb1b01 |
| Value | Count | Frequency (%) |
| eef5dbca8d37dfce6db7d7b16dd0525e | 63 | 0.1% |
| 7145a6f0d38ec713897856cbdcfcdb7f | 38 | < 0.1% |
| f28281373ab8815bafafe371218f02ce | 29 | < 0.1% |
| 8823bba1e3301fee652eb06de8ef9435 | 26 | < 0.1% |
| cc074f1c33940c4f0dd904705f98e39e | 24 | < 0.1% |
| b0c2f8c122ebef9f77753f7d167cf634 | 24 | < 0.1% |
| b5292206f96cd5d97359940203a0b510 | 24 | < 0.1% |
| b79b22bb50f78f1afe361661011fd892 | 24 | < 0.1% |
| 7e568736c98c553aea896a5dca746d5a | 22 | < 0.1% |
| e8236fe7b6e1bdd513a500de361e2b87 | 21 | < 0.1% |
| Other values (98400) | 117851 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 237115 | 6.3% |
| 6 | 237048 | 6.3% |
| 5 | 236734 | 6.3% |
| b | 236598 | 6.3% |
| d | 236586 | 6.3% |
| 8 | 236562 | 6.3% |
| f | 236490 | 6.3% |
| 1 | 236390 | 6.3% |
| 0 | 236298 | 6.3% |
| 7 | 236091 | 6.2% |
| Other values (6) | 1414760 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3780672 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 237115 | 6.3% |
| 6 | 237048 | 6.3% |
| 5 | 236734 | 6.3% |
| b | 236598 | 6.3% |
| d | 236586 | 6.3% |
| 8 | 236562 | 6.3% |
| f | 236490 | 6.3% |
| 1 | 236390 | 6.3% |
| 0 | 236298 | 6.3% |
| 7 | 236091 | 6.2% |
| Other values (6) | 1414760 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3780672 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 237115 | 6.3% |
| 6 | 237048 | 6.3% |
| 5 | 236734 | 6.3% |
| b | 236598 | 6.3% |
| d | 236586 | 6.3% |
| 8 | 236562 | 6.3% |
| f | 236490 | 6.3% |
| 1 | 236390 | 6.3% |
| 0 | 236298 | 6.3% |
| 7 | 236091 | 6.2% |
| Other values (6) | 1414760 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3780672 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 237115 | 6.3% |
| 6 | 237048 | 6.3% |
| 5 | 236734 | 6.3% |
| b | 236598 | 6.3% |
| d | 236586 | 6.3% |
| 8 | 236562 | 6.3% |
| f | 236490 | 6.3% |
| 1 | 236390 | 6.3% |
| 0 | 236298 | 6.3% |
| 7 | 236091 | 6.2% |
| Other values (6) | 1414760 |
review_score
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Memory size | 6.8 MiB |
| 5.0 | |
|---|---|
| 4.0 | |
| 1.0 | |
| 3.0 | |
| 2.0 | 4162 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4.0 |
|---|---|
| 2nd row | 4.0 |
| 3rd row | 4.0 |
| 4th row | 4.0 |
| 5th row | 5.0 |
Common Values
| Value | Count | Frequency (%) |
| 5.0 | 66343 | |
| 4.0 | 22319 | 18.7% |
| 1.0 | 15428 | 12.9% |
| 3.0 | 9894 | 8.3% |
| 2.0 | 4162 | 3.5% |
| (Missing) | 997 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 5.0 | 66343 | |
| 4.0 | 22319 | 18.9% |
| 1.0 | 15428 | 13.1% |
| 3.0 | 9894 | 8.4% |
| 2.0 | 4162 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 118146 | |
| 0 | 118146 | |
| 5 | 66343 | |
| 4 | 22319 | 6.3% |
| 1 | 15428 | 4.4% |
| 3 | 9894 | 2.8% |
| 2 | 4162 | 1.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 354438 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 118146 | |
| 0 | 118146 | |
| 5 | 66343 | |
| 4 | 22319 | 6.3% |
| 1 | 15428 | 4.4% |
| 3 | 9894 | 2.8% |
| 2 | 4162 | 1.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 354438 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 118146 | |
| 0 | 118146 | |
| 5 | 66343 | |
| 4 | 22319 | 6.3% |
| 1 | 15428 | 4.4% |
| 3 | 9894 | 2.8% |
| 2 | 4162 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 354438 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 118146 | |
| 0 | 118146 | |
| 5 | 66343 | |
| 4 | 22319 | 6.3% |
| 1 | 15428 | 4.4% |
| 3 | 9894 | 2.8% |
| 2 | 4162 | 1.2% |
Missing 
| Distinct | 4527 |
|---|---|
| Distinct (%) | 32.4% |
| Missing | 105154 |
| Missing (%) | 88.3% |
| Memory size | 4.3 MiB |
Length
| Max length | 26 |
|---|---|
| Median length | 20 |
| Mean length | 12.213525 |
| Min length | 1 |
Unique
| Unique | 3095 ? |
|---|---|
| Unique (%) | 22.1% |
Sample
| 1st row | Muito boa a loja |
|---|---|
| 2nd row | Nota dez |
| 3rd row | Ótimo |
| 4th row | NÃO RECOMENDO!!!! |
| 5th row | NÃO RECOMENDO!!!! |
| Value | Count | Frequency (%) |
| recomendo | 2478 | 9.3% |
| produto | 1570 | 5.9% |
| bom | 1521 | 5.7% |
| muito | 1040 | 3.9% |
| super | 1039 | 3.9% |
| não | 937 | 3.5% |
| ótimo | 809 | 3.0% |
| excelente | 769 | 2.9% |
| entrega | 716 | 2.7% |
| recebi | 445 | 1.7% |
| Other values (2100) | 15445 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 21273 | 12.5% |
| e | 18299 | 10.7% |
| 15200 | 8.9% | |
| r | 9902 | 5.8% |
| t | 9433 | 5.5% |
| a | 9158 | 5.4% |
| m | 8444 | 4.9% |
| d | 8214 | 4.8% |
| i | 8084 | 4.7% |
| n | 7660 | 4.5% |
| Other values (115) | 55188 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 170855 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 21273 | 12.5% |
| e | 18299 | 10.7% |
| 15200 | 8.9% | |
| r | 9902 | 5.8% |
| t | 9433 | 5.5% |
| a | 9158 | 5.4% |
| m | 8444 | 4.9% |
| d | 8214 | 4.8% |
| i | 8084 | 4.7% |
| n | 7660 | 4.5% |
| Other values (115) | 55188 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 170855 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 21273 | 12.5% |
| e | 18299 | 10.7% |
| 15200 | 8.9% | |
| r | 9902 | 5.8% |
| t | 9433 | 5.5% |
| a | 9158 | 5.4% |
| m | 8444 | 4.9% |
| d | 8214 | 4.8% |
| i | 8084 | 4.7% |
| n | 7660 | 4.5% |
| Other values (115) | 55188 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 170855 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 21273 | 12.5% |
| e | 18299 | 10.7% |
| 15200 | 8.9% | |
| r | 9902 | 5.8% |
| t | 9433 | 5.5% |
| a | 9158 | 5.4% |
| m | 8444 | 4.9% |
| d | 8214 | 4.8% |
| i | 8084 | 4.7% |
| n | 7660 | 4.5% |
| Other values (115) | 55188 |
Missing 
| Distinct | 36159 |
|---|---|
| Distinct (%) | 72.0% |
| Missing | 68898 |
| Missing (%) | 57.8% |
| Memory size | 11.6 MiB |
Length
| Max length | 208 |
|---|---|
| Median length | 159 |
| Mean length | 70.656662 |
| Min length | 1 |
Unique
| Unique | 29556 ? |
|---|---|
| Unique (%) | 58.8% |
Sample
| 1st row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
|---|---|
| 2nd row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 3rd row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 4th row | Muito bom o produto. |
| 5th row | O produto foi exatamente o que eu esperava e estava descrito no site e chegou bem antes da data prevista. |
| Value | Count | Frequency (%) |
| o | 23016 | 3.8% |
| produto | 21207 | 3.5% |
| e | 20046 | 3.3% |
| a | 15246 | 2.5% |
| de | 14566 | 2.4% |
| não | 13436 | 2.2% |
| do | 13109 | 2.2% |
| que | 10560 | 1.7% |
| prazo | 9427 | 1.6% |
| muito | 9086 | 1.5% |
| Other values (19737) | 456676 |
Most occurring characters
| Value | Count | Frequency (%) |
| 562672 | ||
| o | 350271 | 9.9% |
| e | 340009 | 9.6% |
| a | 282074 | 7.9% |
| r | 200163 | 5.6% |
| i | 163758 | 4.6% |
| t | 161344 | 4.5% |
| d | 150134 | 4.2% |
| n | 138033 | 3.9% |
| s | 134085 | 3.8% |
| Other values (199) | 1067601 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3550144 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 562672 | ||
| o | 350271 | 9.9% |
| e | 340009 | 9.6% |
| a | 282074 | 7.9% |
| r | 200163 | 5.6% |
| i | 163758 | 4.6% |
| t | 161344 | 4.5% |
| d | 150134 | 4.2% |
| n | 138033 | 3.9% |
| s | 134085 | 3.8% |
| Other values (199) | 1067601 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3550144 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 562672 | ||
| o | 350271 | 9.9% |
| e | 340009 | 9.6% |
| a | 282074 | 7.9% |
| r | 200163 | 5.6% |
| i | 163758 | 4.6% |
| t | 161344 | 4.5% |
| d | 150134 | 4.2% |
| n | 138033 | 3.9% |
| s | 134085 | 3.8% |
| Other values (199) | 1067601 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3550144 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 562672 | ||
| o | 350271 | 9.9% |
| e | 340009 | 9.6% |
| a | 282074 | 7.9% |
| r | 200163 | 5.6% |
| i | 163758 | 4.6% |
| t | 161344 | 4.5% |
| d | 150134 | 4.2% |
| n | 138033 | 3.9% |
| s | 134085 | 3.8% |
| Other values (199) | 1067601 |
| Distinct | 636 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Memory size | 930.9 KiB |
| Minimum | 2016-10-02 00:00:00 |
|---|---|
| Maximum | 2018-08-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
| Distinct | 98248 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 997 |
| Missing (%) | 0.8% |
| Memory size | 930.9 KiB |
| Minimum | 2016-10-07 18:32:28 |
|---|---|
| Maximum | 2018-10-29 12:27:35 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
order_item_id
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.196543 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6994889 |
|---|---|
| Coefficient of variation (CV) | 0.58459154 |
| Kurtosis | 103.35482 |
| Mean | 1.196543 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.5517266 |
| Sum | 141563 |
| Variance | 0.48928472 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 103645 | |
| 2 | 10317 | 8.7% |
| 3 | 2396 | 2.0% |
| 4 | 995 | 0.8% |
| 5 | 472 | 0.4% |
| 6 | 265 | 0.2% |
| 7 | 61 | 0.1% |
| 8 | 37 | < 0.1% |
| 9 | 29 | < 0.1% |
| 10 | 26 | < 0.1% |
| Other values (11) | 67 | 0.1% |
| (Missing) | 833 | 0.7% |
| Value | Count | Frequency (%) |
| 1 | 103645 | |
| 2 | 10317 | 8.7% |
| 3 | 2396 | 2.0% |
| 4 | 995 | 0.8% |
| 5 | 472 | 0.4% |
| 6 | 265 | 0.2% |
| 7 | 61 | 0.1% |
| 8 | 37 | < 0.1% |
| 9 | 29 | < 0.1% |
| 10 | 26 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 19 | 3 | < 0.1% |
| 18 | 3 | < 0.1% |
| 17 | 3 | < 0.1% |
| 16 | 3 | < 0.1% |
| 15 | 5 | < 0.1% |
| 14 | 7 | |
| 13 | 8 | |
| 12 | 13 |
product_id
Text
| Distinct | 32951 |
|---|---|
| Distinct (%) | 27.9% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 10.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 17345 ? |
|---|---|
| Unique (%) | 14.7% |
Sample
| 1st row | 87285b34884572647811a353c7ac498a |
|---|---|
| 2nd row | 87285b34884572647811a353c7ac498a |
| 3rd row | 87285b34884572647811a353c7ac498a |
| 4th row | 595fac2a385ac33a80bd5114aec74eb8 |
| 5th row | aa4383b373c6aca5d8797843e5594415 |
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 536 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 528 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 508 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 406 | 0.3% |
| 368c6c730842d78016ad823897a372db | 398 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 391 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 357 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 327 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 295 | 0.2% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 278 | 0.2% |
| Other values (32941) | 114286 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 243128 | 6.4% |
| 9 | 241092 | 6.4% |
| e | 238897 | 6.3% |
| 8 | 238246 | 6.3% |
| 7 | 238157 | 6.3% |
| 4 | 237487 | 6.3% |
| a | 237289 | 6.3% |
| c | 236394 | 6.2% |
| 0 | 236277 | 6.2% |
| 2 | 236110 | 6.2% |
| Other values (6) | 1402843 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3785920 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 243128 | 6.4% |
| 9 | 241092 | 6.4% |
| e | 238897 | 6.3% |
| 8 | 238246 | 6.3% |
| 7 | 238157 | 6.3% |
| 4 | 237487 | 6.3% |
| a | 237289 | 6.3% |
| c | 236394 | 6.2% |
| 0 | 236277 | 6.2% |
| 2 | 236110 | 6.2% |
| Other values (6) | 1402843 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3785920 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 243128 | 6.4% |
| 9 | 241092 | 6.4% |
| e | 238897 | 6.3% |
| 8 | 238246 | 6.3% |
| 7 | 238157 | 6.3% |
| 4 | 237487 | 6.3% |
| a | 237289 | 6.3% |
| c | 236394 | 6.2% |
| 0 | 236277 | 6.2% |
| 2 | 236110 | 6.2% |
| Other values (6) | 1402843 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3785920 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 243128 | 6.4% |
| 9 | 241092 | 6.4% |
| e | 238897 | 6.3% |
| 8 | 238246 | 6.3% |
| 7 | 238157 | 6.3% |
| 4 | 237487 | 6.3% |
| a | 237289 | 6.3% |
| c | 236394 | 6.2% |
| 0 | 236277 | 6.2% |
| 2 | 236110 | 6.2% |
| Other values (6) | 1402843 |
seller_id
Text
| Distinct | 3095 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 10.1 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Unique
| Unique | 487 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
|---|---|
| 2nd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 3rd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 4th row | 289cdb325fb7e7f891c38608bf9e0962 |
| 5th row | 4869f7a5dfa277a7dca6462dcf3b52b2 |
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2155 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2130 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2017 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1893 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1662 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1530 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1477 | 1.2% |
| 7c67e1448b00f6e969d365cea6b010ab | 1463 | 1.2% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1245 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1240 | 1.0% |
| Other values (3085) | 101498 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 256833 | 6.8% |
| c | 250006 | 6.6% |
| 4 | 248481 | 6.6% |
| 6 | 243514 | 6.4% |
| 0 | 242843 | 6.4% |
| a | 241350 | 6.4% |
| b | 240801 | 6.4% |
| 3 | 240746 | 6.4% |
| 9 | 235027 | 6.2% |
| 2 | 233698 | 6.2% |
| Other values (6) | 1352621 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3785920 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 256833 | 6.8% |
| c | 250006 | 6.6% |
| 4 | 248481 | 6.6% |
| 6 | 243514 | 6.4% |
| 0 | 242843 | 6.4% |
| a | 241350 | 6.4% |
| b | 240801 | 6.4% |
| 3 | 240746 | 6.4% |
| 9 | 235027 | 6.2% |
| 2 | 233698 | 6.2% |
| Other values (6) | 1352621 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3785920 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 256833 | 6.8% |
| c | 250006 | 6.6% |
| 4 | 248481 | 6.6% |
| 6 | 243514 | 6.4% |
| 0 | 242843 | 6.4% |
| a | 241350 | 6.4% |
| b | 240801 | 6.4% |
| 3 | 240746 | 6.4% |
| 9 | 235027 | 6.2% |
| 2 | 233698 | 6.2% |
| Other values (6) | 1352621 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3785920 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 256833 | 6.8% |
| c | 250006 | 6.6% |
| 4 | 248481 | 6.6% |
| 6 | 243514 | 6.4% |
| 0 | 242843 | 6.4% |
| a | 241350 | 6.4% |
| b | 240801 | 6.4% |
| 3 | 240746 | 6.4% |
| 9 | 235027 | 6.2% |
| 2 | 233698 | 6.2% |
| Other values (6) | 1352621 |
| Distinct | 93318 |
|---|---|
| Distinct (%) | 78.9% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 930.9 KiB |
| Minimum | 2016-09-19 00:15:34 |
|---|---|
| Maximum | 2020-04-09 22:35:08 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
price
Real number (ℝ)
High correlation 
| Distinct | 5968 |
|---|---|
| Distinct (%) | 5.0% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.6466 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 184.10969 |
|---|---|
| Coefficient of variation (CV) | 1.5260247 |
| Kurtosis | 119.15494 |
| Mean | 120.6466 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.8925735 |
| Sum | 14273700 |
| Variance | 33896.378 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2619 | 2.2% |
| 69.9 | 2113 | 1.8% |
| 49.9 | 2051 | 1.7% |
| 89.9 | 1644 | 1.4% |
| 99.9 | 1526 | 1.3% |
| 39.9 | 1403 | 1.2% |
| 29.9 | 1387 | 1.2% |
| 19.9 | 1284 | 1.1% |
| 79.9 | 1282 | 1.1% |
| 29.99 | 1228 | 1.0% |
| Other values (5958) | 101773 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 2 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3 | 2 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6729 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 |
freight_value
Real number (ℝ)
| Distinct | 6999 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.032387 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 390 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.28 |
| Q3 | 21.18 |
| 95-th percentile | 45.3 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.1 |
Descriptive statistics
| Standard deviation | 15.83685 |
|---|---|
| Coefficient of variation (CV) | 0.79056234 |
| Kurtosis | 57.635327 |
| Mean | 20.032387 |
| Median Absolute Deviation (MAD) | 3.63 |
| Skewness | 5.5433839 |
| Sum | 2370031.6 |
| Variance | 250.80583 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3861 | 3.2% |
| 7.78 | 2355 | 2.0% |
| 11.85 | 1999 | 1.7% |
| 14.1 | 1992 | 1.7% |
| 18.23 | 1632 | 1.4% |
| 7.39 | 1573 | 1.3% |
| 16.11 | 1211 | 1.0% |
| 15.23 | 1064 | 0.9% |
| 8.72 | 970 | 0.8% |
| 16.79 | 930 | 0.8% |
| Other values (6989) | 100723 |
| Value | Count | Frequency (%) |
| 0 | 390 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 9 | < 0.1% |
| 0.06 | 13 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
Missing 
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2542 |
| Missing (%) | 2.1% |
| Memory size | 8.1 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 32 |
| Mean length | 14.876202 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | utilidades_domesticas |
|---|---|
| 2nd row | utilidades_domesticas |
| 3rd row | utilidades_domesticas |
| 4th row | perfumaria |
| 5th row | automotivo |
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11988 | 10.3% |
| beleza_saude | 10032 | 8.6% |
| esporte_lazer | 9004 | 7.7% |
| moveis_decoracao | 8832 | 7.6% |
| informatica_acessorios | 8150 | 7.0% |
| utilidades_domesticas | 7380 | 6.3% |
| relogios_presentes | 6213 | 5.3% |
| telefonia | 4726 | 4.1% |
| ferramentas_jardim | 4590 | 3.9% |
| automotivo | 4400 | 3.8% |
| Other values (63) | 41286 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 210541 | |
| a | 208834 | |
| s | 172854 | |
| o | 171612 | |
| i | 115171 | 6.6% |
| r | 111455 | 6.4% |
| _ | 110493 | 6.4% |
| t | 83288 | 4.8% |
| c | 82435 | 4.8% |
| m | 78683 | 4.5% |
| Other values (18) | 389214 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1734580 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 210541 | |
| a | 208834 | |
| s | 172854 | |
| o | 171612 | |
| i | 115171 | 6.6% |
| r | 111455 | 6.4% |
| _ | 110493 | 6.4% |
| t | 83288 | 4.8% |
| c | 82435 | 4.8% |
| m | 78683 | 4.5% |
| Other values (18) | 389214 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1734580 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 210541 | |
| a | 208834 | |
| s | 172854 | |
| o | 171612 | |
| i | 115171 | 6.6% |
| r | 111455 | 6.4% |
| _ | 110493 | 6.4% |
| t | 83288 | 4.8% |
| c | 82435 | 4.8% |
| m | 78683 | 4.5% |
| Other values (18) | 389214 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1734580 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 210541 | |
| a | 208834 | |
| s | 172854 | |
| o | 171612 | |
| i | 115171 | 6.6% |
| r | 111455 | 6.4% |
| _ | 110493 | 6.4% |
| t | 83288 | 4.8% |
| c | 82435 | 4.8% |
| m | 78683 | 4.5% |
| Other values (18) | 389214 |
product_name_lenght
Real number (ℝ)
Missing 
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2542 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.767498 |
| Minimum | 5 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 42 |
| median | 52 |
| Q3 | 57 |
| 95-th percentile | 60 |
| Maximum | 76 |
| Range | 71 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.03354 |
|---|---|
| Coefficient of variation (CV) | 0.20574236 |
| Kurtosis | 0.14950788 |
| Mean | 48.767498 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.90489402 |
| Sum | 5686339 |
| Variance | 100.67193 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59 | 8679 | 7.3% |
| 60 | 8070 | 6.8% |
| 56 | 6847 | 5.7% |
| 58 | 6819 | 5.7% |
| 57 | 6302 | 5.3% |
| 55 | 5833 | 4.9% |
| 54 | 5529 | 4.6% |
| 53 | 4357 | 3.7% |
| 52 | 4328 | 3.6% |
| 49 | 3690 | 3.1% |
| Other values (56) | 56147 |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 15 | < 0.1% |
| 10 | 9 | < 0.1% |
| 11 | 11 | < 0.1% |
| 12 | 38 | |
| 13 | 26 | |
| 14 | 47 |
| Value | Count | Frequency (%) |
| 76 | 1 | < 0.1% |
| 72 | 9 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 3 | < 0.1% |
| 66 | 1 | < 0.1% |
| 64 | 174 | 0.1% |
| 63 | 1350 | |
| 62 | 167 | 0.1% |
| 61 | 241 | 0.2% |
product_description_lenght
Real number (ℝ)
Missing 
| Distinct | 2960 |
|---|---|
| Distinct (%) | 2.5% |
| Missing | 2542 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 785.96782 |
| Minimum | 4 |
|---|---|
| Maximum | 3992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 160 |
| Q1 | 346 |
| median | 600 |
| Q3 | 983 |
| 95-th percentile | 2123 |
| Maximum | 3992 |
| Range | 3988 |
| Interquartile range (IQR) | 637 |
Descriptive statistics
| Standard deviation | 652.58412 |
|---|---|
| Coefficient of variation (CV) | 0.83029369 |
| Kurtosis | 4.9299321 |
| Mean | 785.96782 |
| Median Absolute Deviation (MAD) | 296 |
| Skewness | 2.0121562 |
| Sum | 91644634 |
| Variance | 425866.03 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 341 | 711 | 0.6% |
| 1893 | 667 | 0.6% |
| 348 | 648 | 0.5% |
| 492 | 594 | 0.5% |
| 903 | 594 | 0.5% |
| 245 | 587 | 0.5% |
| 366 | 537 | 0.5% |
| 236 | 516 | 0.4% |
| 340 | 487 | 0.4% |
| 919 | 442 | 0.4% |
| Other values (2950) | 110818 | |
| (Missing) | 2542 | 2.1% |
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 7 | |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 4 | |
| 28 | 2 | < 0.1% |
| 30 | 8 | |
| 31 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 6 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
product_photos_qty
Real number (ℝ)
Missing 
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2542 |
| Missing (%) | 2.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2051612 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.7174519 |
|---|---|
| Coefficient of variation (CV) | 0.7788328 |
| Kurtosis | 4.8200793 |
| Mean | 2.2051612 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.9087497 |
| Sum | 257124 |
| Variance | 2.9496409 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58957 | |
| 2 | 23054 | 19.3% |
| 3 | 12978 | 10.9% |
| 4 | 8863 | 7.4% |
| 5 | 5599 | 4.7% |
| 6 | 3945 | 3.3% |
| 7 | 1560 | 1.3% |
| 8 | 774 | 0.6% |
| 10 | 354 | 0.3% |
| 9 | 318 | 0.3% |
| Other values (9) | 199 | 0.2% |
| (Missing) | 2542 | 2.1% |
| Value | Count | Frequency (%) |
| 1 | 58957 | |
| 2 | 23054 | 19.3% |
| 3 | 12978 | 10.9% |
| 4 | 8863 | 7.4% |
| 5 | 5599 | 4.7% |
| 6 | 3945 | 3.3% |
| 7 | 1560 | 1.3% |
| 8 | 774 | 0.6% |
| 9 | 318 | 0.3% |
| 10 | 354 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 60 | 0.1% |
| 11 | 73 | 0.1% |
| 10 | 354 |
product_weight_g
Real number (ℝ)
High correlation 
| Distinct | 2204 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 853 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2112.2507 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9850 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3786.6951 |
|---|---|
| Coefficient of variation (CV) | 1.7927299 |
| Kurtosis | 16.01826 |
| Mean | 2112.2507 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.5830918 |
| Sum | 2.4985814 × 108 |
| Variance | 14339060 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 7093 | 6.0% |
| 150 | 5410 | 4.5% |
| 250 | 4741 | 4.0% |
| 300 | 4429 | 3.7% |
| 400 | 3787 | 3.2% |
| 100 | 3666 | 3.1% |
| 350 | 3291 | 2.8% |
| 500 | 2856 | 2.4% |
| 600 | 2838 | 2.4% |
| 700 | 2148 | 1.8% |
| Other values (2194) | 78031 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 991 | |
| 53 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 303 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
product_length_cm
Real number (ℝ)
High correlation 
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 853 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.265145 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.189367 |
|---|---|
| Coefficient of variation (CV) | 0.53491788 |
| Kurtosis | 3.6785662 |
| Mean | 30.265145 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.7456849 |
| Sum | 3580064 |
| Variance | 262.09561 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 18363 | 15.4% |
| 20 | 10999 | 9.2% |
| 30 | 7951 | 6.7% |
| 17 | 6202 | 5.2% |
| 18 | 5909 | 5.0% |
| 19 | 4898 | 4.1% |
| 25 | 4871 | 4.1% |
| 40 | 4360 | 3.7% |
| 22 | 4000 | 3.4% |
| 50 | 3163 | 2.7% |
| Other values (89) | 47574 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 96 | 0.1% |
| 12 | 41 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 138 | 0.1% |
| 15 | 220 | 0.2% |
| 16 | 18363 |
| Value | Count | Frequency (%) |
| 105 | 335 | |
| 104 | 35 | < 0.1% |
| 103 | 46 | < 0.1% |
| 102 | 60 | 0.1% |
| 101 | 108 | 0.1% |
| 100 | 429 | |
| 99 | 36 | < 0.1% |
| 98 | 50 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
product_height_cm
Real number (ℝ)
High correlation 
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 853 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.619706 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.453584 |
|---|---|
| Coefficient of variation (CV) | 0.80949592 |
| Kurtosis | 7.2778781 |
| Mean | 16.619706 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.2389625 |
| Sum | 1965945 |
| Variance | 180.99892 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 10374 | 8.7% |
| 20 | 6915 | 5.8% |
| 15 | 6896 | 5.8% |
| 12 | 6520 | 5.5% |
| 11 | 6432 | 5.4% |
| 2 | 5254 | 4.4% |
| 4 | 4910 | 4.1% |
| 8 | 4873 | 4.1% |
| 5 | 4776 | 4.0% |
| 16 | 4765 | 4.0% |
| Other values (92) | 56575 |
| Value | Count | Frequency (%) |
| 2 | 5254 | |
| 3 | 2821 | 2.4% |
| 4 | 4910 | |
| 5 | 4776 | |
| 6 | 3576 | 3.0% |
| 7 | 4387 | |
| 8 | 4873 | |
| 9 | 3408 | 2.9% |
| 10 | 10374 | |
| 11 | 6432 |
| Value | Count | Frequency (%) |
| 105 | 139 | |
| 104 | 14 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 43 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
product_width_cm
Real number (ℝ)
High correlation 
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 853 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.074799 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.749139 |
|---|---|
| Coefficient of variation (CV) | 0.50917622 |
| Kurtosis | 4.5530162 |
| Mean | 23.074799 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.707171 |
| Sum | 2729518 |
| Variance | 138.04227 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12701 | 10.7% |
| 11 | 11144 | 9.4% |
| 15 | 9376 | 7.9% |
| 16 | 8810 | 7.4% |
| 30 | 8045 | 6.8% |
| 12 | 5711 | 4.8% |
| 13 | 5491 | 4.6% |
| 14 | 4846 | 4.1% |
| 18 | 4192 | 3.5% |
| 40 | 4157 | 3.5% |
| Other values (85) | 43817 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 29 | < 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 83 | 0.1% |
| 11 | 11144 | |
| 12 | 5711 | |
| 13 | 5491 | |
| 14 | 4846 | |
| 15 | 9376 |
| Value | Count | Frequency (%) |
| 118 | 8 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 43 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
zip_code_prefix
Real number (ℝ)
High correlation 
| Distinct | 2246 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24442.41 |
| Minimum | 1001 |
|---|---|
| Maximum | 99730 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 2972 |
| Q1 | 6429 |
| median | 13660 |
| Q3 | 27972 |
| 95-th percentile | 88308 |
| Maximum | 99730 |
| Range | 98729 |
| Interquartile range (IQR) | 21543 |
Descriptive statistics
| Standard deviation | 27573.005 |
|---|---|
| Coefficient of variation (CV) | 1.1280804 |
| Kurtosis | 0.93697995 |
| Mean | 24442.41 |
| Median Absolute Deviation (MAD) | 8123 |
| Skewness | 1.5561361 |
| Sum | 2.8917816 × 109 |
| Variance | 7.6027058 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14940 | 8373 | 7.0% |
| 5849 | 2145 | 1.8% |
| 15025 | 2098 | 1.8% |
| 9015 | 1899 | 1.6% |
| 13405 | 1678 | 1.4% |
| 8577 | 1556 | 1.3% |
| 4782 | 1549 | 1.3% |
| 3204 | 1477 | 1.2% |
| 4160 | 1268 | 1.1% |
| 13232 | 1255 | 1.1% |
| Other values (2236) | 95012 |
| Value | Count | Frequency (%) |
| 1001 | 22 | < 0.1% |
| 1021 | 41 | < 0.1% |
| 1022 | 5 | < 0.1% |
| 1023 | 5 | < 0.1% |
| 1026 | 323 | |
| 1031 | 129 | 0.1% |
| 1035 | 18 | < 0.1% |
| 1039 | 1 | < 0.1% |
| 1040 | 25 | < 0.1% |
| 1041 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99730 | 12 | < 0.1% |
| 99700 | 2 | < 0.1% |
| 99670 | 1 | < 0.1% |
| 99500 | 61 | |
| 99300 | 2 | < 0.1% |
| 98975 | 22 | < 0.1% |
| 98920 | 2 | < 0.1% |
| 98910 | 14 | < 0.1% |
| 98803 | 66 | |
| 98780 | 4 | < 0.1% |
seller_city
Text
| Distinct | 611 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 7.6 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 31 |
| Mean length | 10.102451 |
| Min length | 2 |
Unique
| Unique | 64 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | maua |
|---|---|
| 2nd row | maua |
| 3rd row | maua |
| 4th row | belo horizonte |
| 5th row | guariba |
| Value | Count | Frequency (%) |
| sao | 36362 | 17.9% |
| paulo | 29574 | 14.5% |
| ibitinga | 8373 | 4.1% |
| rio | 5930 | 2.9% |
| do | 5524 | 2.7% |
| preto | 5518 | 2.7% |
| de | 4192 | 2.1% |
| jose | 4085 | 2.0% |
| santo | 3270 | 1.6% |
| andre | 3164 | 1.6% |
| Other values (640) | 97267 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 198772 | |
| o | 146215 | |
| i | 102111 | 8.5% |
| 85009 | 7.1% | |
| r | 78220 | 6.5% |
| s | 76216 | 6.4% |
| e | 64170 | 5.4% |
| u | 62907 | 5.3% |
| p | 58419 | 4.9% |
| l | 56917 | 4.8% |
| Other values (31) | 266265 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1195221 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 198772 | |
| o | 146215 | |
| i | 102111 | 8.5% |
| 85009 | 7.1% | |
| r | 78220 | 6.5% |
| s | 76216 | 6.4% |
| e | 64170 | 5.4% |
| u | 62907 | 5.3% |
| p | 58419 | 4.9% |
| l | 56917 | 4.8% |
| Other values (31) | 266265 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1195221 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 198772 | |
| o | 146215 | |
| i | 102111 | 8.5% |
| 85009 | 7.1% | |
| r | 78220 | 6.5% |
| s | 76216 | 6.4% |
| e | 64170 | 5.4% |
| u | 62907 | 5.3% |
| p | 58419 | 4.9% |
| l | 56917 | 4.8% |
| Other values (31) | 266265 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1195221 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 198772 | |
| o | 146215 | |
| i | 102111 | 8.5% |
| 85009 | 7.1% | |
| r | 78220 | 6.5% |
| s | 76216 | 6.4% |
| e | 64170 | 5.4% |
| u | 62907 | 5.3% |
| p | 58419 | 4.9% |
| l | 56917 | 4.8% |
| Other values (31) | 266265 |
seller_state
Categorical
High correlation  Imbalance 
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 833 |
| Missing (%) | 0.7% |
| Memory size | 6.7 MiB |
| SP | |
|---|---|
| MG | |
| PR | |
| RJ | 5036 |
| SC | 4271 |
| Other values (18) | 6216 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 84377 | |
| MG | 9314 | 7.8% |
| PR | 9096 | 7.6% |
| RJ | 5036 | 4.2% |
| SC | 4271 | 3.6% |
| RS | 2294 | 1.9% |
| DF | 949 | 0.8% |
| BA | 700 | 0.6% |
| GO | 550 | 0.5% |
| PE | 465 | 0.4% |
| Other values (13) | 1258 | 1.1% |
| (Missing) | 833 | 0.7% |
Length
| Value | Count | Frequency (%) |
| sp | 84377 | |
| mg | 9314 | 7.9% |
| pr | 9096 | 7.7% |
| rj | 5036 | 4.3% |
| sc | 4271 | 3.6% |
| rs | 2294 | 1.9% |
| df | 949 | 0.8% |
| ba | 700 | 0.6% |
| go | 550 | 0.5% |
| pe | 465 | 0.4% |
| Other values (13) | 1258 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 94002 | |
| S | 91402 | |
| R | 16496 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 236620 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 94002 | |
| S | 91402 | |
| R | 16496 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 236620 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 94002 | |
| S | 91402 | |
| R | 16496 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 236620 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 94002 | |
| S | 91402 | |
| R | 16496 | 7.0% |
| M | 9934 | 4.2% |
| G | 9864 | 4.2% |
| J | 5036 | 2.1% |
| C | 4375 | 1.8% |
| A | 1122 | 0.5% |
| E | 968 | 0.4% |
| D | 949 | 0.4% |
| Other values (6) | 2472 | 1.0% |
geolocation_lat
Real number (ℝ)
High correlation 
| Distinct | 2239 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 1098 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -22.797849 |
| Minimum | -36.605374 |
|---|---|
| Maximum | -2.5460792 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 118045 |
| Negative (%) | 99.1% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | -36.605374 |
|---|---|
| 5-th percentile | -26.322991 |
| Q1 | -23.609026 |
| median | -23.422076 |
| Q3 | -21.766477 |
| 95-th percentile | -19.849883 |
| Maximum | -2.5460792 |
| Range | 34.059295 |
| Interquartile range (IQR) | 1.8425493 |
Descriptive statistics
| Standard deviation | 2.6904204 |
|---|---|
| Coefficient of variation (CV) | -0.11801202 |
| Kurtosis | 18.250517 |
| Mean | -22.797849 |
| Median Absolute Deviation (MAD) | 0.53597732 |
| Skewness | 2.7582692 |
| Sum | -2691172.1 |
| Variance | 7.2383618 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -21.76647685 | 8373 | 7.0% |
| -23.65111484 | 2145 | 1.8% |
| -20.80243626 | 2098 | 1.8% |
| -23.66570346 | 1899 | 1.6% |
| -22.71683929 | 1678 | 1.4% |
| -23.48262344 | 1556 | 1.3% |
| -23.693986 | 1549 | 1.3% |
| -23.59798552 | 1477 | 1.2% |
| -23.62358155 | 1268 | 1.1% |
| -23.20706431 | 1255 | 1.1% |
| Other values (2229) | 94747 |
| Value | Count | Frequency (%) |
| -36.60537441 | 4 | < 0.1% |
| -32.07951338 | 18 | < 0.1% |
| -31.77241287 | 2 | < 0.1% |
| -31.74423096 | 11 | < 0.1% |
| -31.32151917 | 1 | < 0.1% |
| -30.1594693 | 77 | |
| -30.1100209 | 19 | < 0.1% |
| -30.10330372 | 6 | < 0.1% |
| -30.09981943 | 5 | < 0.1% |
| -30.08061351 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| -2.546079234 | 410 | |
| -3.135622683 | 3 | < 0.1% |
| -3.719036598 | 14 | < 0.1% |
| -3.723306129 | 3 | < 0.1% |
| -3.723672447 | 1 | < 0.1% |
| -3.743987899 | 4 | < 0.1% |
| -3.759209507 | 1 | < 0.1% |
| -3.769923 | 35 | < 0.1% |
| -3.780360995 | 12 | < 0.1% |
| -3.783814827 | 16 | < 0.1% |
geolocation_lng
Real number (ℝ)
High correlation 
| Distinct | 2239 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 1098 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -47.238603 |
| Minimum | -67.809656 |
|---|---|
| Maximum | -34.847856 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 118045 |
| Negative (%) | 99.1% |
| Memory size | 930.9 KiB |
Quantile statistics
| Minimum | -67.809656 |
|---|---|
| 5-th percentile | -51.368949 |
| Q1 | -48.831547 |
| median | -46.755211 |
| Q3 | -46.518082 |
| 95-th percentile | -43.297621 |
| Maximum | -34.847856 |
| Range | 32.9618 |
| Interquartile range (IQR) | 2.3134654 |
Descriptive statistics
| Standard deviation | 2.3411036 |
|---|---|
| Coefficient of variation (CV) | -0.049559122 |
| Kurtosis | 4.8442036 |
| Mean | -47.238603 |
| Median Absolute Deviation (MAD) | 0.72882376 |
| Skewness | 0.55253099 |
| Sum | -5576280.8 |
| Variance | 5.4807663 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -48.83154738 | 8373 | 7.0% |
| -46.75521082 | 2145 | 1.8% |
| -49.39562407 | 2098 | 1.8% |
| -46.51808197 | 1899 | 1.6% |
| -47.65736585 | 1678 | 1.4% |
| -46.37448953 | 1556 | 1.3% |
| -46.70188324 | 1549 | 1.3% |
| -46.55547279 | 1477 | 1.2% |
| -46.61056007 | 1268 | 1.1% |
| -46.76073521 | 1255 | 1.1% |
| Other values (2229) | 94747 |
| Value | Count | Frequency (%) |
| -67.8096558 | 1 | < 0.1% |
| -64.28394646 | 4 | < 0.1% |
| -63.88797299 | 6 | < 0.1% |
| -61.95720116 | 8 | < 0.1% |
| -60.02346888 | 3 | < 0.1% |
| -57.08632042 | 1 | < 0.1% |
| -56.10296014 | 52 | |
| -56.06797233 | 37 | |
| -55.49644289 | 56 | |
| -54.96989318 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| -34.84785618 | 1 | < 0.1% |
| -34.8557625 | 9 | < 0.1% |
| -34.89678629 | 3 | < 0.1% |
| -34.89853108 | 16 | < 0.1% |
| -34.90155285 | 1 | < 0.1% |
| -34.91839939 | 6 | < 0.1% |
| -34.93222646 | 386 | |
| -35.12509238 | 16 | < 0.1% |
| -35.20164321 | 23 | < 0.1% |
| -35.20826027 | 16 | < 0.1% |
geolocation_city
Text
| Distinct | 595 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 1098 |
| Missing (%) | 0.9% |
| Memory size | 7.9 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 23 |
| Mean length | 10.075361 |
| Min length | 3 |
Unique
| Unique | 55 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | maua |
|---|---|
| 2nd row | maua |
| 3rd row | maua |
| 4th row | belo horizonte |
| 5th row | guariba |
| Value | Count | Frequency (%) |
| sao | 30528 | 15.1% |
| paulo | 29515 | 14.6% |
| ibitinga | 8373 | 4.1% |
| são | 5968 | 3.0% |
| rio | 5905 | 2.9% |
| do | 5604 | 2.8% |
| preto | 5400 | 2.7% |
| de | 3879 | 1.9% |
| jose | 3675 | 1.8% |
| santo | 3285 | 1.6% |
| Other values (639) | 99814 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 191810 | |
| o | 144781 | |
| i | 100598 | 8.5% |
| 83901 | 7.1% | |
| r | 77632 | 6.5% |
| s | 75861 | 6.4% |
| u | 63166 | 5.3% |
| e | 62314 | 5.2% |
| p | 57905 | 4.9% |
| l | 56870 | 4.8% |
| Other values (25) | 274508 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1189346 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 191810 | |
| o | 144781 | |
| i | 100598 | 8.5% |
| 83901 | 7.1% | |
| r | 77632 | 6.5% |
| s | 75861 | 6.4% |
| u | 63166 | 5.3% |
| e | 62314 | 5.2% |
| p | 57905 | 4.9% |
| l | 56870 | 4.8% |
| Other values (25) | 274508 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1189346 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 191810 | |
| o | 144781 | |
| i | 100598 | 8.5% |
| 83901 | 7.1% | |
| r | 77632 | 6.5% |
| s | 75861 | 6.4% |
| u | 63166 | 5.3% |
| e | 62314 | 5.2% |
| p | 57905 | 4.9% |
| l | 56870 | 4.8% |
| Other values (25) | 274508 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1189346 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 191810 | |
| o | 144781 | |
| i | 100598 | 8.5% |
| 83901 | 7.1% | |
| r | 77632 | 6.5% |
| s | 75861 | 6.4% |
| u | 63166 | 5.3% |
| e | 62314 | 5.2% |
| p | 57905 | 4.9% |
| l | 56870 | 4.8% |
| Other values (25) | 274508 |
geolocation_state
Categorical
High correlation  Imbalance 
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1098 |
| Missing (%) | 0.9% |
| Memory size | 6.7 MiB |
| SP | |
|---|---|
| MG | |
| PR | |
| RJ | 5204 |
| SC | 4459 |
| Other values (17) | 6174 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | MG |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 83572 | |
| MG | 9424 | 7.9% |
| PR | 9212 | 7.7% |
| RJ | 5204 | 4.4% |
| SC | 4459 | 3.7% |
| RS | 2298 | 1.9% |
| DF | 908 | 0.8% |
| BA | 704 | 0.6% |
| GO | 550 | 0.5% |
| PE | 465 | 0.4% |
| Other values (12) | 1249 | 1.0% |
| (Missing) | 1098 | 0.9% |
Length
| Value | Count | Frequency (%) |
| sp | 83572 | |
| mg | 9424 | 8.0% |
| pr | 9212 | 7.8% |
| rj | 5204 | 4.4% |
| sc | 4459 | 3.8% |
| rs | 2298 | 1.9% |
| df | 908 | 0.8% |
| ba | 704 | 0.6% |
| go | 550 | 0.5% |
| pe | 465 | 0.4% |
| Other values (12) | 1249 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| P | 93305 | |
| S | 90790 | |
| R | 16782 | 7.1% |
| M | 10044 | 4.3% |
| G | 9974 | 4.2% |
| J | 5204 | 2.2% |
| C | 4563 | 1.9% |
| A | 1118 | 0.5% |
| E | 969 | 0.4% |
| D | 908 | 0.4% |
| Other values (6) | 2433 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 236090 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| P | 93305 | |
| S | 90790 | |
| R | 16782 | 7.1% |
| M | 10044 | 4.3% |
| G | 9974 | 4.2% |
| J | 5204 | 2.2% |
| C | 4563 | 1.9% |
| A | 1118 | 0.5% |
| E | 969 | 0.4% |
| D | 908 | 0.4% |
| Other values (6) | 2433 | 1.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 236090 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| P | 93305 | |
| S | 90790 | |
| R | 16782 | 7.1% |
| M | 10044 | 4.3% |
| G | 9974 | 4.2% |
| J | 5204 | 2.2% |
| C | 4563 | 1.9% |
| A | 1118 | 0.5% |
| E | 969 | 0.4% |
| D | 908 | 0.4% |
| Other values (6) | 2433 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 236090 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| P | 93305 | |
| S | 90790 | |
| R | 16782 | 7.1% |
| M | 10044 | 4.3% |
| G | 9974 | 4.2% |
| J | 5204 | 2.2% |
| C | 4563 | 1.9% |
| A | 1118 | 0.5% |
| E | 969 | 0.4% |
| D | 908 | 0.4% |
| Other values (6) | 2433 | 1.0% |
product_category_name_english
Text
Missing 
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 2567 |
| Missing (%) | 2.2% |
| Memory size | 7.9 MiB |
Length
| Max length | 39 |
|---|---|
| Median length | 31 |
| Mean length | 12.988299 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | housewares |
|---|---|
| 2nd row | housewares |
| 3rd row | housewares |
| 4th row | perfumery |
| 5th row | auto |
| Value | Count | Frequency (%) |
| bed_bath_table | 11988 | 10.3% |
| health_beauty | 10032 | 8.6% |
| sports_leisure | 9004 | 7.7% |
| furniture_decor | 8832 | 7.6% |
| computers_accessories | 8150 | 7.0% |
| housewares | 7380 | 6.3% |
| watches_gifts | 6213 | 5.3% |
| telephony | 4726 | 4.1% |
| garden_tools | 4590 | 3.9% |
| auto | 4400 | 3.8% |
| Other values (61) | 41261 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 185298 | |
| s | 142057 | 9.4% |
| t | 133341 | 8.8% |
| o | 111892 | 7.4% |
| r | 105808 | 7.0% |
| a | 102466 | 6.8% |
| _ | 102216 | 6.8% |
| u | 78227 | 5.2% |
| c | 72479 | 4.8% |
| i | 63331 | 4.2% |
| Other values (15) | 417009 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1514124 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 185298 | |
| s | 142057 | 9.4% |
| t | 133341 | 8.8% |
| o | 111892 | 7.4% |
| r | 105808 | 7.0% |
| a | 102466 | 6.8% |
| _ | 102216 | 6.8% |
| u | 78227 | 5.2% |
| c | 72479 | 4.8% |
| i | 63331 | 4.2% |
| Other values (15) | 417009 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1514124 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 185298 | |
| s | 142057 | 9.4% |
| t | 133341 | 8.8% |
| o | 111892 | 7.4% |
| r | 105808 | 7.0% |
| a | 102466 | 6.8% |
| _ | 102216 | 6.8% |
| u | 78227 | 5.2% |
| c | 72479 | 4.8% |
| i | 63331 | 4.2% |
| Other values (15) | 417009 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1514124 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 185298 | |
| s | 142057 | 9.4% |
| t | 133341 | 8.8% |
| o | 111892 | 7.4% |
| r | 105808 | 7.0% |
| a | 102466 | 6.8% |
| _ | 102216 | 6.8% |
| u | 78227 | 5.2% |
| c | 72479 | 4.8% |
| i | 63331 | 4.2% |
| Other values (15) | 417009 |
Interactions
Correlations
| customer_state | customer_zip_code_prefix | freight_value | geolocation_lat | geolocation_lng | geolocation_state | order_item_id | order_status | payment_installments | payment_sequential | payment_type | payment_value | price | product_description_lenght | product_height_cm | product_length_cm | product_name_lenght | product_photos_qty | product_weight_g | product_width_cm | review_score | seller_state | zip_code_prefix | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_state | 1.000 | 0.896 | 0.085 | 0.051 | 0.052 | 0.056 | 0.013 | 0.026 | 0.032 | 0.026 | 0.033 | 0.029 | 0.020 | 0.026 | 0.019 | 0.017 | 0.013 | 0.014 | 0.028 | 0.016 | 0.048 | 0.053 | 0.069 |
| customer_zip_code_prefix | 0.896 | 1.000 | 0.466 | -0.003 | -0.009 | 0.066 | -0.009 | 0.022 | 0.069 | -0.009 | 0.029 | 0.106 | 0.070 | 0.031 | 0.019 | 0.008 | 0.015 | 0.026 | 0.026 | -0.002 | 0.041 | 0.065 | 0.060 |
| freight_value | 0.085 | 0.466 | 1.000 | 0.073 | -0.065 | 0.048 | -0.056 | 0.015 | 0.191 | 0.017 | 0.009 | 0.423 | 0.433 | 0.117 | 0.284 | 0.284 | 0.034 | 0.011 | 0.448 | 0.275 | 0.015 | 0.048 | 0.257 |
| geolocation_lat | 0.051 | -0.003 | 0.073 | 1.000 | 0.045 | 0.754 | 0.012 | 0.008 | 0.043 | 0.011 | 0.018 | 0.063 | 0.065 | -0.083 | -0.009 | 0.035 | -0.004 | -0.131 | 0.073 | 0.096 | 0.013 | 0.750 | 0.273 |
| geolocation_lng | 0.052 | -0.009 | -0.065 | 0.045 | 1.000 | 0.882 | -0.012 | 0.025 | -0.032 | -0.003 | 0.015 | -0.045 | -0.036 | 0.130 | 0.009 | -0.069 | -0.087 | 0.034 | -0.074 | -0.074 | 0.015 | 0.880 | -0.406 |
| geolocation_state | 0.056 | 0.066 | 0.048 | 0.754 | 0.882 | 1.000 | 0.000 | 0.029 | 0.033 | 0.016 | 0.020 | 0.036 | 0.052 | 0.111 | 0.066 | 0.084 | 0.069 | 0.040 | 0.078 | 0.058 | 0.023 | 0.996 | 0.926 |
| order_item_id | 0.013 | -0.009 | -0.056 | 0.012 | -0.012 | 0.000 | 1.000 | 0.002 | 0.061 | -0.008 | 0.021 | 0.257 | -0.116 | -0.032 | 0.018 | 0.007 | -0.021 | -0.065 | 0.000 | -0.004 | 0.041 | 0.000 | -0.011 |
| order_status | 0.026 | 0.022 | 0.015 | 0.008 | 0.025 | 0.029 | 0.002 | 1.000 | 0.005 | 0.026 | 0.037 | 0.015 | 0.014 | 0.016 | 0.016 | 0.014 | 0.019 | 0.013 | 0.011 | 0.004 | 0.149 | 0.029 | 0.013 |
| payment_installments | 0.032 | 0.069 | 0.191 | 0.043 | -0.032 | 0.033 | 0.061 | 0.005 | 1.000 | -0.178 | 0.236 | 0.395 | 0.315 | 0.033 | 0.106 | 0.109 | 0.016 | -0.003 | 0.198 | 0.125 | 0.027 | 0.033 | 0.065 |
| payment_sequential | 0.026 | -0.009 | 0.017 | 0.011 | -0.003 | 0.016 | -0.008 | 0.026 | -0.178 | 1.000 | 0.198 | -0.215 | -0.005 | -0.013 | 0.013 | 0.034 | -0.003 | -0.005 | 0.030 | 0.028 | 0.012 | 0.016 | 0.007 |
| payment_type | 0.033 | 0.029 | 0.009 | 0.018 | 0.015 | 0.020 | 0.021 | 0.037 | 0.236 | 0.198 | 1.000 | 0.018 | 0.014 | 0.020 | 0.015 | 0.022 | 0.011 | 0.004 | 0.018 | 0.020 | 0.010 | 0.021 | 0.018 |
| payment_value | 0.029 | 0.106 | 0.423 | 0.063 | -0.045 | 0.036 | 0.257 | 0.015 | 0.395 | -0.215 | 0.018 | 1.000 | 0.789 | 0.169 | 0.305 | 0.229 | 0.025 | -0.011 | 0.449 | 0.232 | 0.028 | 0.036 | 0.160 |
| price | 0.020 | 0.070 | 0.433 | 0.065 | -0.036 | 0.052 | -0.116 | 0.014 | 0.315 | -0.005 | 0.014 | 0.789 | 1.000 | 0.211 | 0.327 | 0.266 | 0.042 | 0.029 | 0.514 | 0.271 | 0.012 | 0.052 | 0.175 |
| product_description_lenght | 0.026 | 0.031 | 0.117 | -0.083 | 0.130 | 0.111 | -0.032 | 0.016 | 0.033 | -0.013 | 0.020 | 0.169 | 0.211 | 1.000 | 0.135 | -0.021 | 0.073 | 0.111 | 0.095 | -0.081 | 0.015 | 0.112 | 0.001 |
| product_height_cm | 0.019 | 0.019 | 0.284 | -0.009 | 0.009 | 0.066 | 0.018 | 0.016 | 0.106 | 0.013 | 0.015 | 0.305 | 0.327 | 0.135 | 1.000 | 0.248 | -0.057 | -0.079 | 0.532 | 0.338 | 0.018 | 0.065 | 0.049 |
| product_length_cm | 0.017 | 0.008 | 0.284 | 0.035 | -0.069 | 0.084 | 0.007 | 0.014 | 0.109 | 0.034 | 0.022 | 0.229 | 0.266 | -0.021 | 0.248 | 1.000 | 0.060 | 0.005 | 0.619 | 0.632 | 0.018 | 0.084 | 0.067 |
| product_name_lenght | 0.013 | 0.015 | 0.034 | -0.004 | -0.087 | 0.069 | -0.021 | 0.019 | 0.016 | -0.003 | 0.011 | 0.025 | 0.042 | 0.073 | -0.057 | 0.060 | 1.000 | 0.163 | 0.076 | 0.065 | 0.013 | 0.070 | 0.009 |
| product_photos_qty | 0.014 | 0.026 | 0.011 | -0.131 | 0.034 | 0.040 | -0.065 | 0.013 | -0.003 | -0.005 | 0.004 | -0.011 | 0.029 | 0.111 | -0.079 | 0.005 | 0.163 | 1.000 | 0.003 | -0.015 | 0.016 | 0.040 | -0.078 |
| product_weight_g | 0.028 | 0.026 | 0.448 | 0.073 | -0.074 | 0.078 | 0.000 | 0.011 | 0.198 | 0.030 | 0.018 | 0.449 | 0.514 | 0.095 | 0.532 | 0.619 | 0.076 | 0.003 | 1.000 | 0.621 | 0.020 | 0.078 | 0.096 |
| product_width_cm | 0.016 | -0.002 | 0.275 | 0.096 | -0.074 | 0.058 | -0.004 | 0.004 | 0.125 | 0.028 | 0.020 | 0.232 | 0.271 | -0.081 | 0.338 | 0.632 | 0.065 | -0.015 | 0.621 | 1.000 | 0.014 | 0.057 | 0.077 |
| review_score | 0.048 | 0.041 | 0.015 | 0.013 | 0.015 | 0.023 | 0.041 | 0.149 | 0.027 | 0.012 | 0.010 | 0.028 | 0.012 | 0.015 | 0.018 | 0.018 | 0.013 | 0.016 | 0.020 | 0.014 | 1.000 | 0.023 | 0.021 |
| seller_state | 0.053 | 0.065 | 0.048 | 0.750 | 0.880 | 0.996 | 0.000 | 0.029 | 0.033 | 0.016 | 0.021 | 0.036 | 0.052 | 0.112 | 0.065 | 0.084 | 0.070 | 0.040 | 0.078 | 0.057 | 0.023 | 1.000 | 0.920 |
| zip_code_prefix | 0.069 | 0.060 | 0.257 | 0.273 | -0.406 | 0.926 | -0.011 | 0.013 | 0.065 | 0.007 | 0.018 | 0.160 | 0.175 | 0.001 | 0.049 | 0.067 | 0.009 | -0.078 | 0.096 | 0.077 | 0.021 | 0.920 | 1.000 |
Missing values
Sample
| order_id | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | payment_sequential | payment_type | payment_installments | payment_value | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | zip_code_prefix | seller_city | seller_state | geolocation_lat | geolocation_lng | geolocation_city | geolocation_state | product_category_name_english | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 1.0 | credit_card | 1.0 | 18.12 | a54f0611adc9ed256b57ede6b6eb5114 | 4.0 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350.0 | maua | SP | -23.680114 | -46.452454 | maua | SP | housewares |
| 1 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 3.0 | voucher | 1.0 | 2.00 | a54f0611adc9ed256b57ede6b6eb5114 | 4.0 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350.0 | maua | SP | -23.680114 | -46.452454 | maua | SP | housewares |
| 2 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | 2.0 | voucher | 1.0 | 18.59 | a54f0611adc9ed256b57ede6b6eb5114 | 4.0 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 | 1.0 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 9350.0 | maua | SP | -23.680114 | -46.452454 | maua | SP | housewares |
| 3 | 53cdb2fc8bc7dce0b6741e2150273451 | b0830fb4747a6c6d20dea0b8c802d7ef | delivered | 2018-07-24 20:41:37 | 2018-07-26 03:24:27 | 2018-07-26 14:31:00 | 2018-08-07 15:27:45 | 2018-08-13 00:00:00 | af07308b275d755c9edb36a90c618231 | 47813 | barreiras | BA | 1.0 | boleto | 1.0 | 141.46 | 8d5266042046a06655c8db133d120ba5 | 4.0 | Muito boa a loja | Muito bom o produto. | 2018-08-08 00:00:00 | 2018-08-08 18:37:50 | 1.0 | 595fac2a385ac33a80bd5114aec74eb8 | 289cdb325fb7e7f891c38608bf9e0962 | 2018-07-30 03:24:27 | 118.70 | 22.76 | perfumaria | 29.0 | 178.0 | 1.0 | 400.0 | 19.0 | 13.0 | 19.0 | 31570.0 | belo horizonte | SP | -19.810119 | -43.984727 | belo horizonte | MG | perfumery |
| 4 | 47770eb9100c2d0c44946d9cf07ec65d | 41ce2a54c0b03bf3443c3d931a367089 | delivered | 2018-08-08 08:38:49 | 2018-08-08 08:55:23 | 2018-08-08 13:50:00 | 2018-08-17 18:06:29 | 2018-09-04 00:00:00 | 3a653a41f6f9fc3d2a113cf8398680e8 | 75265 | vianopolis | GO | 1.0 | credit_card | 3.0 | 179.12 | e73b67b67587f7644d5bd1a52deb1b01 | 5.0 | NaN | NaN | 2018-08-18 00:00:00 | 2018-08-22 19:07:58 | 1.0 | aa4383b373c6aca5d8797843e5594415 | 4869f7a5dfa277a7dca6462dcf3b52b2 | 2018-08-13 08:55:23 | 159.90 | 19.22 | automotivo | 46.0 | 232.0 | 1.0 | 420.0 | 24.0 | 19.0 | 21.0 | 14840.0 | guariba | SP | -21.362358 | -48.232976 | guariba | SP | auto |
| 5 | 949d5b44dbf5de918fe9c16f97b45f8a | f88197465ea7920adcdbec7375364d82 | delivered | 2017-11-18 19:28:06 | 2017-11-18 19:45:59 | 2017-11-22 13:39:59 | 2017-12-02 00:28:42 | 2017-12-15 00:00:00 | 7c142cf63193a1473d2e66489a9ae977 | 59296 | sao goncalo do amarante | RN | 1.0 | credit_card | 1.0 | 72.20 | 359d03e676b3c069f62cadba8dd3f6e8 | 5.0 | NaN | O produto foi exatamente o que eu esperava e estava descrito no site e chegou bem antes da data prevista. | 2017-12-03 00:00:00 | 2017-12-05 19:21:58 | 1.0 | d0b61bfb1de832b15ba9d266ca96e5b0 | 66922902710d126a0e7d26b0e3805106 | 2017-11-23 19:45:59 | 45.00 | 27.20 | pet_shop | 59.0 | 468.0 | 3.0 | 450.0 | 30.0 | 10.0 | 20.0 | 31842.0 | belo horizonte | MG | -19.840168 | -43.923299 | belo horizonte | MG | pet_shop |
| 6 | ad21c59c0840e6cb83a9ceb5573f8159 | 8ab97904e6daea8866dbdbc4fb7aad2c | delivered | 2018-02-13 21:18:39 | 2018-02-13 22:20:29 | 2018-02-14 19:46:34 | 2018-02-16 18:17:02 | 2018-02-26 00:00:00 | 72632f0f9dd73dfee390c9b22eb56dd6 | 9195 | santo andre | SP | 1.0 | credit_card | 1.0 | 28.62 | e50934924e227544ba8246aeb3770dd4 | 5.0 | NaN | NaN | 2018-02-17 00:00:00 | 2018-02-18 13:02:51 | 1.0 | 65266b2da20d04dbe00c5c2d3bb7859e | 2c9e548be18521d1c43cde1c582c6de8 | 2018-02-19 20:31:37 | 19.90 | 8.72 | papelaria | 38.0 | 316.0 | 4.0 | 250.0 | 51.0 | 15.0 | 15.0 | 8752.0 | mogi das cruzes | SP | -23.551707 | -46.260979 | mogi das cruzes | SP | stationery |
| 7 | a4591c265e18cb1dcee52889e2d8acc3 | 503740e9ca751ccdda7ba28e9ab8f608 | delivered | 2017-07-09 21:57:05 | 2017-07-09 22:10:13 | 2017-07-11 14:58:04 | 2017-07-26 10:57:55 | 2017-08-01 00:00:00 | 80bb27c7c16e8f973207a5086ab329e2 | 86320 | congonhinhas | PR | 1.0 | credit_card | 6.0 | 175.26 | 89b738e70a1ce346db29a20fb2910161 | 4.0 | NaN | NaN | 2017-07-27 00:00:00 | 2017-07-27 22:48:30 | 1.0 | 060cb19345d90064d1015407193c233d | 8581055ce74af1daba164fdbd55a40de | 2017-07-13 22:10:13 | 147.90 | 27.36 | automotivo | 49.0 | 608.0 | 1.0 | 7150.0 | 65.0 | 10.0 | 65.0 | 7112.0 | guarulhos | SP | -23.465304 | -46.511487 | guarulhos | SP | auto |
| 8 | 136cce7faa42fdb2cefd53fdc79a6098 | ed0271e0b7da060a393796590e7b737a | invoiced | 2017-04-11 12:22:08 | 2017-04-13 13:25:17 | NaN | NaN | 2017-05-09 00:00:00 | 36edbb3fb164b1f16485364b6fb04c73 | 98900 | santa rosa | RS | 1.0 | credit_card | 1.0 | 65.95 | e07549ef5311abcc92ba1784b093fb56 | 2.0 | NaN | fiquei triste por n ter me atendido. | 2017-05-13 00:00:00 | 2017-05-13 20:25:42 | 1.0 | a1804276d9941ac0733cfd409f5206eb | dc8798cbf453b7e0f98745e396cc5616 | 2017-04-19 13:25:17 | 49.90 | 16.05 | NaN | NaN | NaN | NaN | 600.0 | 35.0 | 35.0 | 15.0 | 5455.0 | sao paulo | SP | -23.536892 | -46.713111 | sao paulo | SP | NaN |
| 9 | 6514b8ad8028c9f2cc2374ded245783f | 9bdf08b4b3b52b5526ff42d37d47f222 | delivered | 2017-05-16 13:10:30 | 2017-05-16 13:22:11 | 2017-05-22 10:07:46 | 2017-05-26 12:55:51 | 2017-06-07 00:00:00 | 932afa1e708222e5821dac9cd5db4cae | 26525 | nilopolis | RJ | 1.0 | credit_card | 3.0 | 75.16 | 07d67dd06ed5f88bef11ef6b464e79ae | 5.0 | NaN | NaN | 2017-05-27 00:00:00 | 2017-05-28 02:59:57 | 1.0 | 4520766ec412348b8d4caa5e8a18c464 | 16090f2ca825584b5a147ab24aa30c86 | 2017-05-22 13:22:11 | 59.99 | 15.17 | automotivo | 59.0 | 956.0 | 1.0 | 50.0 | 16.0 | 16.0 | 17.0 | 12940.0 | atibaia | SP | -23.112774 | -46.548885 | atibaia | SP | auto |
| order_id | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | payment_sequential | payment_type | payment_installments | payment_value | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | zip_code_prefix | seller_city | seller_state | geolocation_lat | geolocation_lng | geolocation_city | geolocation_state | product_category_name_english | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 119133 | 9115830be804184b91f5c00f6f49f92d | da2124f134f5dfbce9d06f29bdb6c308 | delivered | 2017-10-04 19:57:37 | 2017-10-04 20:07:14 | 2017-10-05 16:52:52 | 2017-10-20 20:25:45 | 2017-11-07 00:00:00 | c716cf2b5b86fb24257cffe9e7969df8 | 78048 | cuiaba | MT | 2.0 | voucher | 1.0 | 64.37 | ebd75732b5804e934123d11ec1f11db0 | 5.0 | NaN | NaN | 2017-10-21 00:00:00 | 2017-10-23 14:48:40 | 2.0 | 49d2e2460386273b195e7e59b43587c3 | 1caf283236cd69af44cbc09a0a1e7d32 | 2017-10-10 20:07:14 | 26.90 | 36.98 | brinquedos | 40.0 | 180.0 | 3.0 | 750.0 | 26.0 | 15.0 | 26.0 | 26020.0 | nova iguacu | RJ | -22.741390 | -43.447927 | nova iguaçu | RJ | toys |
| 119134 | aa04ef5214580b06b10e2a378300db44 | f01a6bfcc730456317e4081fe0c9940e | delivered | 2017-01-27 00:30:03 | 2017-01-27 01:05:25 | 2017-01-30 11:40:16 | 2017-02-07 13:15:25 | 2017-03-17 00:00:00 | e03dbdf5e56c96b106d8115ac336f47f | 35502 | divinopolis | MG | 2.0 | voucher | 1.0 | 250.00 | e8995c053d3db2d9c07407efe7de52dd | 5.0 | NaN | NaN | 2017-02-08 00:00:00 | 2017-02-11 12:37:36 | 1.0 | 9fc063fd34fed29ccc57b7f8e8d03388 | ccc4bbb5f32a6ab2b7066a4130f114e3 | 2017-02-03 00:30:03 | 370.00 | 19.43 | beleza_saude | 48.0 | 657.0 | 1.0 | 750.0 | 38.0 | 12.0 | 25.0 | 80310.0 | curitiba | PR | -25.464029 | -49.304728 | curitiba | PR | health_beauty |
| 119135 | aa04ef5214580b06b10e2a378300db44 | f01a6bfcc730456317e4081fe0c9940e | delivered | 2017-01-27 00:30:03 | 2017-01-27 01:05:25 | 2017-01-30 11:40:16 | 2017-02-07 13:15:25 | 2017-03-17 00:00:00 | e03dbdf5e56c96b106d8115ac336f47f | 35502 | divinopolis | MG | 1.0 | credit_card | 5.0 | 139.43 | e8995c053d3db2d9c07407efe7de52dd | 5.0 | NaN | NaN | 2017-02-08 00:00:00 | 2017-02-11 12:37:36 | 1.0 | 9fc063fd34fed29ccc57b7f8e8d03388 | ccc4bbb5f32a6ab2b7066a4130f114e3 | 2017-02-03 00:30:03 | 370.00 | 19.43 | beleza_saude | 48.0 | 657.0 | 1.0 | 750.0 | 38.0 | 12.0 | 25.0 | 80310.0 | curitiba | PR | -25.464029 | -49.304728 | curitiba | PR | health_beauty |
| 119136 | 880675dff2150932f1601e1c07eadeeb | 47cd45a6ac7b9fb16537df2ccffeb5ac | delivered | 2017-02-23 09:05:12 | 2017-02-23 09:15:11 | 2017-03-01 10:22:52 | 2017-03-06 11:08:08 | 2017-03-22 00:00:00 | 831ce3f1bacbd424fc4e38fbd4d66d29 | 5127 | sao paulo | SP | 1.0 | credit_card | 3.0 | 155.99 | 96e8f371a3983122b739944537e15525 | 5.0 | NaN | NaN | 2017-03-07 00:00:00 | 2017-03-11 15:42:41 | 1.0 | ea73128566d1b082e5101ce46f8107c7 | 391fc6631aebcf3004804e51b40bcf1e | 2017-02-27 09:05:12 | 139.90 | 16.09 | moveis_decoracao | 63.0 | 254.0 | 2.0 | 2500.0 | 49.0 | 13.0 | 41.0 | 14940.0 | ibitinga | SP | -21.766477 | -48.831547 | ibitinga | SP | furniture_decor |
| 119137 | 9c5dedf39a927c1b2549525ed64a053c | 39bd1228ee8140590ac3aca26f2dfe00 | delivered | 2017-03-09 09:54:05 | 2017-03-09 09:54:05 | 2017-03-10 11:18:03 | 2017-03-17 15:08:01 | 2017-03-28 00:00:00 | 6359f309b166b0196dbf7ad2ac62bb5a | 12209 | sao jose dos campos | SP | 1.0 | credit_card | 3.0 | 85.08 | e262b3f92d1ce917aa412a9406cf61a6 | 5.0 | NaN | NaN | 2017-03-22 00:00:00 | 2017-03-23 11:02:08 | 1.0 | ac35486adb7b02598c182c2ff2e05254 | e24fc9fcd865784fb25705606fe3dfe7 | 2017-03-15 09:54:05 | 72.00 | 13.08 | beleza_saude | 50.0 | 1517.0 | 1.0 | 1175.0 | 22.0 | 13.0 | 18.0 | 12913.0 | braganca paulista | SP | -22.957505 | -46.524886 | braganca paulista | SP | health_beauty |
| 119138 | 63943bddc261676b46f01ca7ac2f7bd8 | 1fca14ff2861355f6e5f14306ff977a7 | delivered | 2018-02-06 12:58:58 | 2018-02-06 13:10:37 | 2018-02-07 23:22:42 | 2018-02-28 17:37:56 | 2018-03-02 00:00:00 | da62f9e57a76d978d02ab5362c509660 | 11722 | praia grande | SP | 1.0 | credit_card | 3.0 | 195.00 | 29bb71b2760d0f876dfa178a76bc4734 | 4.0 | NaN | So uma peça que veio rachado mas tudo bem rs | 2018-03-01 00:00:00 | 2018-03-02 17:50:01 | 1.0 | f1d4ce8c6dd66c47bbaa8c6781c2a923 | 1f9ab4708f3056ede07124aad39a2554 | 2018-02-12 13:10:37 | 174.90 | 20.10 | bebes | 52.0 | 828.0 | 4.0 | 4950.0 | 40.0 | 10.0 | 40.0 | 17602.0 | tupa | SP | -21.935321 | -50.497562 | tupa | SP | baby |
| 119139 | 83c1379a015df1e13d02aae0204711ab | 1aa71eb042121263aafbe80c1b562c9c | delivered | 2017-08-27 14:46:43 | 2017-08-27 15:04:16 | 2017-08-28 20:52:26 | 2017-09-21 11:24:17 | 2017-09-27 00:00:00 | 737520a9aad80b3fbbdad19b66b37b30 | 45920 | nova vicosa | BA | 1.0 | credit_card | 5.0 | 271.01 | 371579771219f6db2d830d50805977bb | 5.0 | NaN | Foi entregue antes do prazo. | 2017-09-22 00:00:00 | 2017-09-22 23:10:57 | 1.0 | b80910977a37536adeddd63663f916ad | d50d79cb34e38265a8649c383dcffd48 | 2017-09-05 15:04:16 | 205.99 | 65.02 | eletrodomesticos_2 | 51.0 | 500.0 | 2.0 | 13300.0 | 32.0 | 90.0 | 22.0 | 8290.0 | sao paulo | SP | -23.551013 | -46.448489 | sao paulo | SP | home_appliances_2 |
| 119140 | 11c177c8e97725db2631073c19f07b62 | b331b74b18dc79bcdf6532d51e1637c1 | delivered | 2018-01-08 21:28:27 | 2018-01-08 21:36:21 | 2018-01-12 15:35:03 | 2018-01-25 23:32:54 | 2018-02-15 00:00:00 | 5097a5312c8b157bb7be58ae360ef43c | 28685 | japuiba | RJ | 1.0 | credit_card | 4.0 | 441.16 | 8ab6855b9fe9b812cd03a480a25058a1 | 2.0 | NaN | Foi entregue somente 1. Quero saber do outro produto. | 2018-01-26 00:00:00 | 2018-01-27 09:16:56 | 1.0 | d1c427060a0f73f6b889a5c7c61f2ac4 | a1043bafd471dff536d0c462352beb48 | 2018-01-12 21:36:21 | 179.99 | 40.59 | informatica_acessorios | 59.0 | 1893.0 | 1.0 | 6550.0 | 20.0 | 20.0 | 20.0 | 37175.0 | ilicinea | MG | -20.944706 | -45.827098 | ilicinea | MG | computers_accessories |
| 119141 | 11c177c8e97725db2631073c19f07b62 | b331b74b18dc79bcdf6532d51e1637c1 | delivered | 2018-01-08 21:28:27 | 2018-01-08 21:36:21 | 2018-01-12 15:35:03 | 2018-01-25 23:32:54 | 2018-02-15 00:00:00 | 5097a5312c8b157bb7be58ae360ef43c | 28685 | japuiba | RJ | 1.0 | credit_card | 4.0 | 441.16 | 8ab6855b9fe9b812cd03a480a25058a1 | 2.0 | NaN | Foi entregue somente 1. Quero saber do outro produto. | 2018-01-26 00:00:00 | 2018-01-27 09:16:56 | 2.0 | d1c427060a0f73f6b889a5c7c61f2ac4 | a1043bafd471dff536d0c462352beb48 | 2018-01-12 21:36:21 | 179.99 | 40.59 | informatica_acessorios | 59.0 | 1893.0 | 1.0 | 6550.0 | 20.0 | 20.0 | 20.0 | 37175.0 | ilicinea | MG | -20.944706 | -45.827098 | ilicinea | MG | computers_accessories |
| 119142 | 66dea50a8b16d9b4dee7af250b4be1a5 | edb027a75a1449115f6b43211ae02a24 | delivered | 2018-03-08 20:57:30 | 2018-03-09 11:20:28 | 2018-03-09 22:11:59 | 2018-03-16 13:08:30 | 2018-04-03 00:00:00 | 60350aa974b26ff12caad89e55993bd6 | 83750 | lapa | PR | 1.0 | debit_card | 1.0 | 86.86 | dc9c59b4688062c25758c2be4cafc523 | 5.0 | NaN | NaN | 2018-03-17 00:00:00 | 2018-03-17 16:33:31 | 1.0 | 006619bbed68b000c8ba3f8725d5409e | ececbfcff9804a2d6b40f589df8eef2b | 2018-03-15 10:55:42 | 68.50 | 18.36 | beleza_saude | 45.0 | 569.0 | 1.0 | 150.0 | 16.0 | 7.0 | 15.0 | 14407.0 | franca | SP | -20.502342 | -47.421590 | franca | SP | health_beauty |